Create Staging Tables in Staging Database and Populate the Staging Tables - Continued 9
To Load Stg_Req Table:
Source Vw_ReqA:
Source VW_SIH:
Source Timing::
SQL command Text:
SQL command Text:
SELECT [Job Posting ID] ,[Supplier Response], [Selection Process], [Onboarding],
MIN ([Job Posting Approval/Distribution] ) as [Min_Job Posting Approval/Distribution]
FROM [dbo].[Timing]
Group By [Job Posting ID], [Supplier Response], [Selection Process], [Onboarding]
Sort:
Sort 1:
Sort 2:
Merge Join:
Sort 3:
Merge Join 1:
Data Conversion:
Derived Column:
Derived Column Text:
ISNULL([Str_SIH_Min Presented Bill Rate (ST/Hr)]) ? "0" : [Str_SIH_Min Presented Bill Rate (ST/Hr)]
ISNULL([Str_SIH_Max Presented Bill Rate (ST/Hr)]) ? "0" : [Str_SIH_Max Presented Bill Rate (ST/Hr)]
ISNULL([Str_SIH_Max Requested Bill Rate (ST/Hr)]) ? "0" : [Str_SIH_Max Requested Bill Rate (ST/Hr)]
ISNULL([Str_SIH_Min Requested Bill Rate (ST/Hr)]) ? "0" : [Str_SIH_Min Requested Bill Rate (ST/Hr)]
ISNULL([Str_Min_Job Posting Approval/Distribution]) ? "0" : [Str_Min_Job Posting Approval/Distribution]
OLEDB Destination:
About Derived Column Transformation
https://www.sqlshack.com/ssis-derived-columns-with-multiple-expressions-vs-multiple-transformations/
To Load Stg_Req Table:
Source Vw_ReqA:
Source VW_SIH:
Source Timing::
SQL command Text:
SQL command Text:
SELECT [Job Posting ID] ,[Supplier Response], [Selection Process], [Onboarding],
MIN ([Job Posting Approval/Distribution] ) as [Min_Job Posting Approval/Distribution]
FROM [dbo].[Timing]
Group By [Job Posting ID], [Supplier Response], [Selection Process], [Onboarding]
Sort:
Sort 1:
Sort 2:
Merge Join:
Sort 3:
Merge Join 1:
Data Conversion:
Derived Column:
Derived Column Text:
ISNULL([Str_SIH_Min Presented Bill Rate (ST/Hr)]) ? "0" : [Str_SIH_Min Presented Bill Rate (ST/Hr)]
ISNULL([Str_SIH_Max Presented Bill Rate (ST/Hr)]) ? "0" : [Str_SIH_Max Presented Bill Rate (ST/Hr)]
ISNULL([Str_SIH_Max Requested Bill Rate (ST/Hr)]) ? "0" : [Str_SIH_Max Requested Bill Rate (ST/Hr)]
ISNULL([Str_SIH_Min Requested Bill Rate (ST/Hr)]) ? "0" : [Str_SIH_Min Requested Bill Rate (ST/Hr)]
ISNULL([Str_Min_Job Posting Approval/Distribution]) ? "0" : [Str_Min_Job Posting Approval/Distribution]
OLEDB Destination:
About Derived Column Transformation
https://www.sqlshack.com/ssis-derived-columns-with-multiple-expressions-vs-multiple-transformations/